Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 449578 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 115.3 MiB |
| Average record size in memory | 269.0 B |
Variable types
| Text | 1 |
|---|---|
| DateTime | 1 |
| Numeric | 9 |
| Categorical | 1 |
Reproduction
| Analysis started | 2024-03-21 02:20:11.693045 |
|---|---|
| Analysis finished | 2024-03-21 02:20:40.570682 |
| Duration | 28.88 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
symbol
Text
| Distinct | 1790 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.6 MiB |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Characters and Unicode
| Total characters | 2247890 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CF101 |
|---|---|
| 2nd row | CF103 |
| 3rd row | CF105 |
| 4th row | CF107 |
| 5th row | CF109 |
| Value | Count | Frequency (%) |
| sr209 | 613 | 0.1% |
| sr301 | 610 | 0.1% |
| sr211 | 610 | 0.1% |
| sr309 | 608 | 0.1% |
| sr401 | 606 | 0.1% |
| sr311 | 606 | 0.1% |
| sr305 | 604 | 0.1% |
| sr207 | 603 | 0.1% |
| sr303 | 602 | 0.1% |
| sr307 | 599 | 0.1% |
| Other values (1780) | 443517 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 413616 | |
| 1 | 255816 | 11.4% |
| R | 118169 | 5.3% |
| 3 | 117802 | 5.2% |
| S | 108128 | 4.8% |
| 2 | 106662 | 4.7% |
| M | 99825 | 4.4% |
| 9 | 89431 | 4.0% |
| F | 89327 | 4.0% |
| A | 87958 | 3.9% |
| Other values (21) | 761156 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2247890 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 413616 | |
| 1 | 255816 | 11.4% |
| R | 118169 | 5.3% |
| 3 | 117802 | 5.2% |
| S | 108128 | 4.8% |
| 2 | 106662 | 4.7% |
| M | 99825 | 4.4% |
| 9 | 89431 | 4.0% |
| F | 89327 | 4.0% |
| A | 87958 | 3.9% |
| Other values (21) | 761156 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2247890 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 413616 | |
| 1 | 255816 | 11.4% |
| R | 118169 | 5.3% |
| 3 | 117802 | 5.2% |
| S | 108128 | 4.8% |
| 2 | 106662 | 4.7% |
| M | 99825 | 4.4% |
| 9 | 89431 | 4.0% |
| F | 89327 | 4.0% |
| A | 87958 | 3.9% |
| Other values (21) | 761156 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2247890 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 413616 | |
| 1 | 255816 | 11.4% |
| R | 118169 | 5.3% |
| 3 | 117802 | 5.2% |
| S | 108128 | 4.8% |
| 2 | 106662 | 4.7% |
| M | 99825 | 4.4% |
| 9 | 89431 | 4.0% |
| F | 89327 | 4.0% |
| A | 87958 | 3.9% |
| Other values (21) | 761156 |
date
Date
| Distinct | 3203 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.4 MiB |
| Minimum | 2011-01-04 00:00:00 |
|---|---|
| Maximum | 2024-03-11 00:00:00 |
Histogram with fixed size bins (bins=50)
open
Real number (ℝ)
ZEROS
| Distinct | 17266 |
|---|---|
| Distinct (%) | 3.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3434.5239 |
| Minimum | 0 |
|---|---|
| Maximum | 34680 |
| Zeros | 180376 |
| Zeros (%) | 40.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1924 |
| Q3 | 5750 |
| 95-th percentile | 12760 |
| Maximum | 34680 |
| Range | 34680 |
| Interquartile range (IQR) | 5750 |
Descriptive statistics
| Standard deviation | 4638.7272 |
|---|---|
| Coefficient of variation (CV) | 1.3506172 |
| Kurtosis | 4.8888053 |
| Mean | 3434.5239 |
| Median Absolute Deviation (MAD) | 1924 |
| Skewness | 1.9921614 |
| Sum | 1.5440864 × 109 |
| Variance | 21517790 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 180376 | |
| 2500 | 219 | < 0.1% |
| 2600 | 198 | < 0.1% |
| 2650 | 194 | < 0.1% |
| 2700 | 186 | < 0.1% |
| 2400 | 178 | < 0.1% |
| 2450 | 170 | < 0.1% |
| 2630 | 167 | < 0.1% |
| 2300 | 167 | < 0.1% |
| 2430 | 160 | < 0.1% |
| Other values (17256) | 267563 |
| Value | Count | Frequency (%) |
| 0 | 180376 | |
| 262.2 | 1 | < 0.1% |
| 280 | 1 | < 0.1% |
| 281.4 | 1 | < 0.1% |
| 281.8 | 1 | < 0.1% |
| 282.4 | 1 | < 0.1% |
| 282.6 | 1 | < 0.1% |
| 283 | 1 | < 0.1% |
| 283.4 | 1 | < 0.1% |
| 284 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 34680 | 1 | |
| 34500 | 1 | |
| 34460 | 1 | |
| 34450 | 1 | |
| 34300 | 1 | |
| 34200 | 1 | |
| 34050 | 1 | |
| 34000 | 1 | |
| 33995 | 2 | |
| 33875 | 1 |
high
Real number (ℝ)
ZEROS
| Distinct | 17557 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3461.7976 |
| Minimum | 0 |
|---|---|
| Maximum | 34870 |
| Zeros | 180376 |
| Zeros (%) | 40.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1947 |
| Q3 | 5788 |
| 95-th percentile | 12890 |
| Maximum | 34870 |
| Range | 34870 |
| Interquartile range (IQR) | 5788 |
Descriptive statistics
| Standard deviation | 4673.902 |
|---|---|
| Coefficient of variation (CV) | 1.3501373 |
| Kurtosis | 4.890554 |
| Mean | 3461.7976 |
| Median Absolute Deviation (MAD) | 1947 |
| Skewness | 1.9913691 |
| Sum | 1.5563481 × 109 |
| Variance | 21845360 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 180376 | |
| 2650 | 184 | < 0.1% |
| 2500 | 178 | < 0.1% |
| 2600 | 161 | < 0.1% |
| 2700 | 159 | < 0.1% |
| 2520 | 156 | < 0.1% |
| 2400 | 151 | < 0.1% |
| 2450 | 146 | < 0.1% |
| 2630 | 144 | < 0.1% |
| 2350 | 144 | < 0.1% |
| Other values (17547) | 267779 |
| Value | Count | Frequency (%) |
| 0 | 180376 | |
| 277.4 | 1 | < 0.1% |
| 282.2 | 1 | < 0.1% |
| 284 | 1 | < 0.1% |
| 284.6 | 1 | < 0.1% |
| 286 | 2 | < 0.1% |
| 286.6 | 1 | < 0.1% |
| 287.2 | 1 | < 0.1% |
| 287.8 | 2 | < 0.1% |
| 288 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 34870 | 1 | |
| 34680 | 1 | |
| 34580 | 1 | |
| 34500 | 1 | |
| 34480 | 1 | |
| 34460 | 1 | |
| 34390 | 1 | |
| 34065 | 1 | |
| 34000 | 2 | |
| 33995 | 2 |
low
Real number (ℝ)
ZEROS
| Distinct | 17187 |
|---|---|
| Distinct (%) | 3.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3406.9122 |
| Minimum | 0 |
|---|---|
| Maximum | 34180 |
| Zeros | 180376 |
| Zeros (%) | 40.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1903 |
| Q3 | 5712 |
| 95-th percentile | 12650 |
| Maximum | 34180 |
| Range | 34180 |
| Interquartile range (IQR) | 5712 |
Descriptive statistics
| Standard deviation | 4601.9932 |
|---|---|
| Coefficient of variation (CV) | 1.3507812 |
| Kurtosis | 4.8787692 |
| Mean | 3406.9122 |
| Median Absolute Deviation (MAD) | 1903 |
| Skewness | 1.9917067 |
| Sum | 1.5316728 × 109 |
| Variance | 21178341 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 180376 | |
| 2400 | 194 | < 0.1% |
| 2500 | 186 | < 0.1% |
| 2650 | 177 | < 0.1% |
| 2600 | 175 | < 0.1% |
| 2700 | 175 | < 0.1% |
| 2280 | 163 | < 0.1% |
| 2300 | 162 | < 0.1% |
| 2580 | 161 | < 0.1% |
| 2680 | 154 | < 0.1% |
| Other values (17177) | 267655 |
| Value | Count | Frequency (%) |
| 0 | 180376 | |
| 255.8 | 1 | < 0.1% |
| 270.2 | 1 | < 0.1% |
| 275.8 | 1 | < 0.1% |
| 277.2 | 1 | < 0.1% |
| 278.4 | 1 | < 0.1% |
| 280.6 | 1 | < 0.1% |
| 281 | 1 | < 0.1% |
| 281.4 | 1 | < 0.1% |
| 281.6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 34180 | 1 | |
| 34070 | 1 | |
| 34005 | 1 | |
| 33695 | 1 | |
| 33480 | 1 | |
| 33475 | 1 | |
| 33460 | 1 | |
| 33420 | 1 | |
| 33370 | 1 | |
| 33350 | 1 |
close
Real number (ℝ)
ZEROS
| Distinct | 17503 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3434.0247 |
| Minimum | 0 |
|---|---|
| Maximum | 34250 |
| Zeros | 180376 |
| Zeros (%) | 40.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1924 |
| Q3 | 5750 |
| 95-th percentile | 12760 |
| Maximum | 34250 |
| Range | 34250 |
| Interquartile range (IQR) | 5750 |
Descriptive statistics
| Standard deviation | 4637.4919 |
|---|---|
| Coefficient of variation (CV) | 1.3504539 |
| Kurtosis | 4.8833659 |
| Mean | 3434.0247 |
| Median Absolute Deviation (MAD) | 1924 |
| Skewness | 1.9914675 |
| Sum | 1.543862 × 109 |
| Variance | 21506331 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 180376 | |
| 2700 | 170 | < 0.1% |
| 2600 | 165 | < 0.1% |
| 2500 | 163 | < 0.1% |
| 2650 | 151 | < 0.1% |
| 2630 | 149 | < 0.1% |
| 2480 | 145 | < 0.1% |
| 2520 | 143 | < 0.1% |
| 2590 | 142 | < 0.1% |
| 2550 | 138 | < 0.1% |
| Other values (17493) | 267836 |
| Value | Count | Frequency (%) |
| 0 | 180376 | |
| 277.4 | 1 | < 0.1% |
| 280.6 | 1 | < 0.1% |
| 282.2 | 1 | < 0.1% |
| 283.2 | 3 | < 0.1% |
| 284.4 | 2 | < 0.1% |
| 284.6 | 2 | < 0.1% |
| 285 | 1 | < 0.1% |
| 285.4 | 1 | < 0.1% |
| 286 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 34250 | 1 | |
| 34245 | 1 | |
| 34090 | 1 | |
| 33910 | 1 | |
| 33795 | 1 | |
| 33790 | 1 | |
| 33725 | 1 | |
| 33690 | 1 | |
| 33600 | 1 | |
| 33585 | 1 |
volume
Real number (ℝ)
ZEROS
| Distinct | 77359 |
|---|---|
| Distinct (%) | 17.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50168.462 |
| Minimum | 0 |
|---|---|
| Maximum | 9020298 |
| Zeros | 180129 |
| Zeros (%) | 40.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 14 |
| Q3 | 2756 |
| 95-th percentile | 229165 |
| Maximum | 9020298 |
| Range | 9020298 |
| Interquartile range (IQR) | 2756 |
Descriptive statistics
| Standard deviation | 230972.43 |
|---|---|
| Coefficient of variation (CV) | 4.6039369 |
| Kurtosis | 116.79662 |
| Mean | 50168.462 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 8.7137821 |
| Sum | 2.2554637 × 1010 |
| Variance | 5.3348264 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 180129 | |
| 2 | 11110 | 2.5% |
| 4 | 8085 | 1.8% |
| 6 | 4980 | 1.1% |
| 8 | 4225 | 0.9% |
| 1 | 3493 | 0.8% |
| 10 | 3298 | 0.7% |
| 12 | 2844 | 0.6% |
| 14 | 2261 | 0.5% |
| 16 | 2162 | 0.5% |
| Other values (77349) | 226991 |
| Value | Count | Frequency (%) |
| 0 | 180129 | |
| 1 | 3493 | 0.8% |
| 2 | 11110 | 2.5% |
| 3 | 1975 | 0.4% |
| 4 | 8085 | 1.8% |
| 5 | 1362 | 0.3% |
| 6 | 4980 | 1.1% |
| 7 | 1009 | 0.2% |
| 8 | 4225 | 0.9% |
| 9 | 864 | 0.2% |
| Value | Count | Frequency (%) |
| 9020298 | 1 | |
| 8520802 | 1 | |
| 8394082 | 1 | |
| 8327044 | 1 | |
| 8152542 | 1 | |
| 7620302 | 1 | |
| 7491580 | 1 | |
| 7095116 | 1 | |
| 6740970 | 1 | |
| 6696414 | 1 |
open_interest
Real number (ℝ)
ZEROS
| Distinct | 97323 |
|---|---|
| Distinct (%) | 21.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48193.437 |
| Minimum | 0 |
|---|---|
| Maximum | 2784649 |
| Zeros | 108423 |
| Zeros (%) | 24.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 209 |
| Q3 | 12721.5 |
| 95-th percentile | 289962.7 |
| Maximum | 2784649 |
| Range | 2784649 |
| Interquartile range (IQR) | 12720.5 |
Descriptive statistics
| Standard deviation | 159684.34 |
|---|---|
| Coefficient of variation (CV) | 3.3134043 |
| Kurtosis | 49.247801 |
| Mean | 48193.437 |
| Median Absolute Deviation (MAD) | 209 |
| Skewness | 6.0681671 |
| Sum | 2.1666709 × 1010 |
| Variance | 2.5499089 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 108423 | 24.1% |
| 2 | 20217 | 4.5% |
| 4 | 11740 | 2.6% |
| 6 | 6982 | 1.6% |
| 8 | 5322 | 1.2% |
| 1 | 5133 | 1.1% |
| 10 | 4220 | 0.9% |
| 12 | 3770 | 0.8% |
| 14 | 2825 | 0.6% |
| 16 | 2537 | 0.6% |
| Other values (97313) | 278409 |
| Value | Count | Frequency (%) |
| 0 | 108423 | |
| 1 | 5133 | 1.1% |
| 2 | 20217 | 4.5% |
| 3 | 1942 | 0.4% |
| 4 | 11740 | 2.6% |
| 5 | 820 | 0.2% |
| 6 | 6982 | 1.6% |
| 7 | 564 | 0.1% |
| 8 | 5322 | 1.2% |
| 9 | 398 | 0.1% |
| Value | Count | Frequency (%) |
| 2784649 | 1 | |
| 2778219 | 1 | |
| 2774995 | 1 | |
| 2763784 | 1 | |
| 2738080 | 1 | |
| 2730906 | 1 | |
| 2712606 | 1 | |
| 2708888 | 1 | |
| 2705736 | 1 | |
| 2702689 | 1 |
turnover
Real number (ℝ)
ZEROS
| Distinct | 205431 |
|---|---|
| Distinct (%) | 45.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 203108.88 |
| Minimum | 0 |
|---|---|
| Maximum | 39654756 |
| Zeros | 180129 |
| Zeros (%) | 40.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 54.46 |
| Q3 | 12750.228 |
| 95-th percentile | 1060254.4 |
| Maximum | 39654756 |
| Range | 39654756 |
| Interquartile range (IQR) | 12750.228 |
Descriptive statistics
| Standard deviation | 915672.09 |
|---|---|
| Coefficient of variation (CV) | 4.5082818 |
| Kurtosis | 204.93758 |
| Mean | 203108.88 |
| Median Absolute Deviation (MAD) | 54.46 |
| Skewness | 10.572507 |
| Sum | 9.1313286 × 1010 |
| Variance | 8.3845538 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 180129 | |
| 5.2 | 44 | < 0.1% |
| 10.72 | 44 | < 0.1% |
| 10 | 44 | < 0.1% |
| 10.84 | 42 | < 0.1% |
| 5.66 | 42 | < 0.1% |
| 5.6 | 42 | < 0.1% |
| 5.3 | 42 | < 0.1% |
| 5.4 | 41 | < 0.1% |
| 5.36 | 40 | < 0.1% |
| Other values (205421) | 269068 |
| Value | Count | Frequency (%) |
| 0 | 180129 | |
| 1.67 | 1 | < 0.1% |
| 1.69 | 1 | < 0.1% |
| 1.7 | 1 | < 0.1% |
| 1.71 | 2 | < 0.1% |
| 1.72 | 1 | < 0.1% |
| 1.74 | 2 | < 0.1% |
| 1.78 | 1 | < 0.1% |
| 1.8 | 1 | < 0.1% |
| 1.81 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 39654756.47 | 1 | |
| 39305846.68 | 1 | |
| 36375274.39 | 1 | |
| 36281334.95 | 1 | |
| 35415192.82 | 1 | |
| 34006799.63 | 1 | |
| 33873889.59 | 1 | |
| 33778219.42 | 1 | |
| 33248029.06 | 1 | |
| 33086427.04 | 1 |
settle
Real number (ℝ)
| Distinct | 18291 |
|---|---|
| Distinct (%) | 4.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5531.7246 |
| Minimum | 264.4 |
|---|---|
| Maximum | 34540 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 264.4 |
|---|---|
| 5-th percentile | 713.8 |
| Q1 | 2384 |
| median | 3224 |
| Q3 | 6940 |
| 95-th percentile | 19305 |
| Maximum | 34540 |
| Range | 34275.6 |
| Interquartile range (IQR) | 4556 |
Descriptive statistics
| Standard deviation | 5228.8326 |
|---|---|
| Coefficient of variation (CV) | 0.94524456 |
| Kurtosis | 4.7261832 |
| Mean | 5531.7246 |
| Median Absolute Deviation (MAD) | 1958 |
| Skewness | 2.1245931 |
| Sum | 2.4869417 × 109 |
| Variance | 27340690 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 801.4 | 3091 | 0.7% |
| 2479 | 2651 | 0.6% |
| 2360 | 2473 | 0.6% |
| 3122 | 2193 | 0.5% |
| 2662 | 1860 | 0.4% |
| 2973 | 1749 | 0.4% |
| 3198 | 1204 | 0.3% |
| 2759 | 591 | 0.1% |
| 2444 | 486 | 0.1% |
| 2658 | 434 | 0.1% |
| Other values (18281) | 432846 |
| Value | Count | Frequency (%) |
| 264.4 | 1 | |
| 266 | 1 | |
| 266.2 | 1 | |
| 266.6 | 1 | |
| 268.4 | 1 | |
| 269.4 | 1 | |
| 273.2 | 1 | |
| 279 | 1 | |
| 282 | 1 | |
| 282.2 | 1 |
| Value | Count | Frequency (%) |
| 34540 | 1 | |
| 34360 | 1 | |
| 34270 | 1 | |
| 34130 | 1 | |
| 34065 | 1 | |
| 34040 | 1 | |
| 33960 | 1 | |
| 33815 | 1 | |
| 33695 | 1 | |
| 33650 | 1 |
pre_settle
Real number (ℝ)
| Distinct | 18282 |
|---|---|
| Distinct (%) | 4.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5531.8589 |
| Minimum | 264.4 |
|---|---|
| Maximum | 34540 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 264.4 |
|---|---|
| 5-th percentile | 713 |
| Q1 | 2384 |
| median | 3222 |
| Q3 | 6939 |
| 95-th percentile | 19310 |
| Maximum | 34540 |
| Range | 34275.6 |
| Interquartile range (IQR) | 4555 |
Descriptive statistics
| Standard deviation | 5229.7585 |
|---|---|
| Coefficient of variation (CV) | 0.945389 |
| Kurtosis | 4.7271734 |
| Mean | 5531.8589 |
| Median Absolute Deviation (MAD) | 1958 |
| Skewness | 2.1249463 |
| Sum | 2.487002 × 109 |
| Variance | 27350374 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 801.4 | 3083 | 0.7% |
| 2479 | 2647 | 0.6% |
| 2360 | 2470 | 0.5% |
| 3122 | 2190 | 0.5% |
| 2662 | 1857 | 0.4% |
| 2973 | 1753 | 0.4% |
| 3198 | 1202 | 0.3% |
| 2759 | 594 | 0.1% |
| 2444 | 489 | 0.1% |
| 2658 | 435 | 0.1% |
| Other values (18272) | 432858 |
| Value | Count | Frequency (%) |
| 264.4 | 1 | |
| 266 | 1 | |
| 266.2 | 1 | |
| 266.6 | 1 | |
| 268.4 | 1 | |
| 269.4 | 1 | |
| 273.2 | 1 | |
| 279 | 1 | |
| 282 | 1 | |
| 282.2 | 1 |
| Value | Count | Frequency (%) |
| 34540 | 1 | |
| 34360 | 1 | |
| 34270 | 1 | |
| 34130 | 1 | |
| 34065 | 1 | |
| 34040 | 1 | |
| 33960 | 1 | |
| 33815 | 1 | |
| 33695 | 1 | |
| 33650 | 1 |
variety
Categorical
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 25.3 MiB |
| TA | |
|---|---|
| FG | |
| SM | 27894 |
| SF | 27894 |
| MA | 27070 |
| Other values (26) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 899156 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CF |
|---|---|
| 2nd row | CF |
| 3rd row | CF |
| 4th row | CF |
| 5th row | CF |
Common Values
| Value | Count | Frequency (%) |
| TA | 38436 | 8.5% |
| FG | 32752 | 7.3% |
| SM | 27894 | 6.2% |
| SF | 27894 | 6.2% |
| MA | 27070 | 6.0% |
| SR | 24714 | 5.5% |
| ZC | 23730 | 5.3% |
| CF | 19190 | 4.3% |
| RM | 18967 | 4.2% |
| CY | 18905 | 4.2% |
| Other values (21) | 190026 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| ta | 38436 | 8.5% |
| fg | 32752 | 7.3% |
| sm | 27894 | 6.2% |
| sf | 27894 | 6.2% |
| ma | 27070 | 6.0% |
| sr | 24714 | 5.5% |
| zc | 23730 | 5.3% |
| cf | 19190 | 4.3% |
| rm | 18967 | 4.2% |
| cy | 18905 | 4.2% |
| Other values (21) | 190026 |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 118169 | |
| S | 108128 | |
| M | 99825 | |
| F | 89327 | |
| A | 87958 | |
| C | 74789 | |
| T | 46606 | 5.2% |
| P | 42139 | 4.7% |
| G | 32752 | 3.6% |
| I | 32723 | 3.6% |
| Other values (11) | 166740 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 899156 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| R | 118169 | |
| S | 108128 | |
| M | 99825 | |
| F | 89327 | |
| A | 87958 | |
| C | 74789 | |
| T | 46606 | 5.2% |
| P | 42139 | 4.7% |
| G | 32752 | 3.6% |
| I | 32723 | 3.6% |
| Other values (11) | 166740 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 899156 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| R | 118169 | |
| S | 108128 | |
| M | 99825 | |
| F | 89327 | |
| A | 87958 | |
| C | 74789 | |
| T | 46606 | 5.2% |
| P | 42139 | 4.7% |
| G | 32752 | 3.6% |
| I | 32723 | 3.6% |
| Other values (11) | 166740 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 899156 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| R | 118169 | |
| S | 108128 | |
| M | 99825 | |
| F | 89327 | |
| A | 87958 | |
| C | 74789 | |
| T | 46606 | 5.2% |
| P | 42139 | 4.7% |
| G | 32752 | 3.6% |
| I | 32723 | 3.6% |
| Other values (11) | 166740 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| symbol | date | open | high | low | close | volume | open_interest | turnover | settle | pre_settle | variety | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CF101 | 2011-01-04 00:00:00 | 28500.0 | 28750.0 | 28500.0 | 28570.0 | 84 | 1546 | 1205.23 | 28695.0 | 28660.0 | CF |
| 1 | CF103 | 2011-01-04 00:00:00 | 28190.0 | 28335.0 | 27985.0 | 28225.0 | 336 | 1808 | 4727.67 | 28140.0 | 28190.0 | CF |
| 2 | CF105 | 2011-01-04 00:00:00 | 28175.0 | 28250.0 | 27845.0 | 28070.0 | 18396 | 52144 | 257920.03 | 28040.0 | 28125.0 | CF |
| 3 | CF107 | 2011-01-04 00:00:00 | 28115.0 | 28280.0 | 27915.0 | 28125.0 | 298 | 1600 | 4186.86 | 28100.0 | 28200.0 | CF |
| 4 | CF109 | 2011-01-04 00:00:00 | 28250.0 | 28350.0 | 27895.0 | 28145.0 | 598186 | 227588 | 8411871.51 | 28125.0 | 28215.0 | CF |
| 5 | CF111 | 2011-01-04 00:00:00 | 26260.0 | 26390.0 | 25880.0 | 26145.0 | 50188 | 47924 | 656301.57 | 26155.0 | 26285.0 | CF |
| 6 | ER101 | 2011-01-04 00:00:00 | 2264.0 | 2266.0 | 2264.0 | 2266.0 | 8 | 3476 | 18.12 | 2266.0 | 2241.0 | ER |
| 7 | ER103 | 2011-01-04 00:00:00 | 2306.0 | 2334.0 | 2306.0 | 2317.0 | 20 | 286 | 46.34 | 2317.0 | 2306.0 | ER |
| 8 | ER105 | 2011-01-04 00:00:00 | 2354.0 | 2372.0 | 2348.0 | 2368.0 | 21054 | 71626 | 49745.19 | 2363.0 | 2347.0 | ER |
| 9 | ER107 | 2011-01-04 00:00:00 | 2370.0 | 2392.0 | 2370.0 | 2388.0 | 248 | 6330 | 590.99 | 2383.0 | 2370.0 | ER |
| symbol | date | open | high | low | close | volume | open_interest | turnover | settle | pre_settle | variety | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 449568 | ZC405 | 2024-03-11 00:00:00 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 801.4 | 801.4 | ZC |
| 449569 | ZC406 | 2024-03-11 00:00:00 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 801.4 | 801.4 | ZC |
| 449570 | ZC407 | 2024-03-11 00:00:00 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 801.4 | 801.4 | ZC |
| 449571 | ZC408 | 2024-03-11 00:00:00 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 801.4 | 801.4 | ZC |
| 449572 | ZC409 | 2024-03-11 00:00:00 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 801.4 | 801.4 | ZC |
| 449573 | ZC410 | 2024-03-11 00:00:00 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 801.4 | 801.4 | ZC |
| 449574 | ZC411 | 2024-03-11 00:00:00 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 801.4 | 801.4 | ZC |
| 449575 | ZC412 | 2024-03-11 00:00:00 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 801.4 | 801.4 | ZC |
| 449576 | ZC501 | 2024-03-11 00:00:00 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 801.4 | 801.4 | ZC |
| 449577 | ZC502 | 2024-03-11 00:00:00 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 801.4 | 801.4 | ZC |